Define Over clause in sql server.

Question

Manish Kumar · Answer

The Over clause combined with partition by is used to break up data into partitions.The specified function operates for each function
Syntax
FUNCTION(..) over(PARTITION BY COL1,COL2)
Any of the following function can be used
COUNT(),AVG(),SUM(),MIN(),MAX(),ROW_NUMBER(),RANK(),DENSE_RANK() etc

interview

Define Over clause in sql server.

Manish Kumar

Can you answer this question?

1 Answers

Liked By